FAQ汇萃 >> Oracle 专栏 >> 显示表和列的注释 [查看别人的评论]

由 webmaster 发布于: 2001-03-03 09:45

Exclamation

set pages 50000
set null 'No Comments'

tti 'Table Comments'
col comments format a29 wrap word

select * from user_tab_comments;

tti 'Column Comments'
col comments format a18 wrap word
break on table_name skip 1
select * from user_col_comments;
clear break

set null ''
set pages 23




点这里对该文章发表评论

该文章总得分是 4 分,你认为它对你有帮助吗? [非常多](1) [有一些](0) [无帮助](0) [是灌水](0)

Copyright © 2001 - 2009 JSP001.com . All Rights Reserved